worked fine for me. Maybe once again they were working on the site and you just caught them at a weak moment. Earlier this post was up.......

----- Original Message -----
From: john@johnsblog.com
To: letterbox-usa@yahoogroups.com
Sent: Thursday, July 27, 2006 7:16 AM
Looks OK to me now. You may have caught the page while I
was making a change. I've been working to make the queries
faster and sometimes create problems as I'm working.

monica

----- Original Message -----
From: Chris
To: letterbox-usa@yahoogroups.com
Sent: Thursday, July 27, 2006 3:03 PM
Subject: [LbNA] LBNA website


anybody else having problems with the LBNA site? when i go to
member services and click on boxes i found i get this long message:

Database error: Invalid SQL: INSERT INTO `SearchLog` ( `MemberID` ,
`datim` , `query`, `queryTime` ) VALUES ( 11519, '2006-07-27
15:02:42', 'SELECT F.type, B.lboxName, M.Name, M.bStatusOK,
S.stFullName, B.ownerID, B.city, B.county, B.placeDate, B.clueDiff,
B.terrainDiff, M.MemberID, B.ID, B.redir, B.link, B.numBoxes,
B.active, S.stAbbr, F.dateFound, B.expireDate FROM Found AS F JOIN
Boxes AS B JOIN Members AS M JOIN States AS S WHERE B.ID = F.BoxID
AND S.stateID = B.state AND B.ownerID=M.MemberID AND
(F.MemberID="11519" AND F.type='Attempted') AND B.active=-1 ORDER BY
S.stFullName, B.county, B.city', '0.0097' )
MySQL Error: 1064 (You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'Attempted') AND B.active=-1 ORDER BY
S.stFullName, B.county, B.)
Session halted.
:"

anybody else having a similar problem?





[Non-text portions of this message have been removed]

no sorry. but the yahoo groups are slow for me.

david (team new hampshire)
http://teamnewhampshire.blogspot.com


Chris wrote:
anybody else having problems with the LBNA site? when i go to
member services and click on boxes i found i get this long message:

Database error: Invalid SQL: INSERT INTO `SearchLog` ( `MemberID` ,
`datim` , `query`, `queryTime` ) VALUES ( 11519, '2006-07-27
15:02:42', 'SELECT F.type, B.lboxName, M.Name, M.bStatusOK,
S.stFullName, B.ownerID, B.city, B.county, B.placeDate, B.clueDiff,
B.terrainDiff, M.MemberID, B.ID, B.redir, B.link, B.numBoxes,
B.active, S.stAbbr, F.dateFound, B.expireDate FROM Found AS F JOIN
Boxes AS B JOIN Members AS M JOIN States AS S WHERE B.ID = F.BoxID
AND S.stateID = B.state AND B.ownerID=M.MemberID AND
(F.MemberID="11519" AND F.type='Attempted') AND B.active=-1 ORDER BY
S.stFullName, B.county, B.city', '0.0097' )
MySQL Error: 1064 (You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'Attempted') AND B.active=-1 ORDER BY
S.stFullName, B.county, B.)
Session halted.
:"

anybody else having a similar problem?






---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.

[Non-text portions of this message have been removed]

I got the same message today.
Brenda of the Mud Puppies

Chris wrote: anybody else having problems with the LBNA site? when i go to
member services and click on boxes i found i get this long message:

Database error: Invalid SQL: INSERT INTO `SearchLog` ( `MemberID` ,
`datim` , `query`, `queryTime` ) VALUES ( 11519, '2006-07-27
15:02:42', 'SELECT F.type, B.lboxName, M.Name, M.bStatusOK,
S.stFullName, B.ownerID, B.city, B.county, B.placeDate, B.clueDiff,
B.terrainDiff, M.MemberID, B.ID, B.redir, B.link, B.numBoxes,
B.active, S.stAbbr, F.dateFound, B.expireDate FROM Found AS F JOIN
Boxes AS B JOIN Members AS M JOIN States AS S WHERE B.ID = F.BoxID
AND S.stateID = B.state AND B.ownerID=M.MemberID AND
(F.MemberID="11519" AND F.type='Attempted') AND B.active=-1 ORDER BY
S.stFullName, B.county, B.city', '0.0097' )
MySQL Error: 1064 (You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'Attempted') AND B.active=-1 ORDER BY
S.stFullName, B.county, B.)
Session halted.
:"

anybody else having a similar problem?






---------------------------------
Groups are talking. We´re listening. Check out the handy changes to Yahoo! Groups.

[Non-text portions of this message have been removed]

I found the problem. Thanks!

Choi

On Thu, 27 Jul 2006 13:58:38 -0700 (PDT)
BWunder wrote:
> I got the same message today.
> Brenda of the Mud Puppies
>
> Chris wrote:
> anybody else having
>problems with the LBNA site? when i go to
> member services and click on boxes i found i get this
>long message:
>
> Database error: Invalid SQL: INSERT INTO `SearchLog` (
>`MemberID` ,
> `datim` , `query`, `queryTime` ) VALUES ( 11519,
>'2006-07-27
> 15:02:42', 'SELECT F.type, B.lboxName, M.Name,
>M.bStatusOK,
> S.stFullName, B.ownerID, B.city, B.county, B.placeDate,
>B.clueDiff,
> B.terrainDiff, M.MemberID, B.ID, B.redir, B.link,
>B.numBoxes,
> B.active, S.stAbbr, F.dateFound, B.expireDate FROM Found
>AS F JOIN
> Boxes AS B JOIN Members AS M JOIN States AS S WHERE B.ID
>= F.BoxID
> AND S.stateID = B.state AND B.ownerID=M.MemberID AND
> (F.MemberID="11519" AND F.type='Attempted') AND
>B.active=-1 ORDER BY
> S.stFullName, B.county, B.city', '0.0097' )
> MySQL Error: 1064 (You have an error in your SQL syntax.
>Check the
> manual that corresponds to your MySQL server version for
>the right
> syntax to use near 'Attempted') AND B.active=-1 ORDER BY
> S.stFullName, B.county, B.)
> Session halted.
> :"
>
> anybody else having a similar problem?
>
>
>
>
>
>
> ---------------------------------
> Groups are talking. We´re listening. Check out the
>handy changes to Yahoo! Groups.
>
> [Non-text portions of this message have been removed]
>

Yes I am, in Conn., I posted a similar querie the other day. I
believe Choi is working on it.
Connfederate

--- In letterbox-usa@yahoogroups.com, "Chris" wrote:
>
> anybody else having problems with the LBNA site? when i go to
> member services and click on boxes i found i get this long message:
>
> Database error: Invalid SQL: INSERT INTO `SearchLog` ( `MemberID` ,
> `datim` , `query`, `queryTime` ) VALUES ( 11519, '2006-07-27
> 15:02:42', 'SELECT F.type, B.lboxName, M.Name, M.bStatusOK,
> S.stFullName, B.ownerID, B.city, B.county, B.placeDate, B.clueDiff,
> B.terrainDiff, M.MemberID, B.ID, B.redir, B.link, B.numBoxes,
> B.active, S.stAbbr, F.dateFound, B.expireDate FROM Found AS F JOIN
> Boxes AS B JOIN Members AS M JOIN States AS S WHERE B.ID = F.BoxID
> AND S.stateID = B.state AND B.ownerID=M.MemberID AND
> (F.MemberID="11519" AND F.type='Attempted') AND B.active=-1 ORDER
BY
> S.stFullName, B.county, B.city', '0.0097' )
> MySQL Error: 1064 (You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'Attempted') AND B.active=-1 ORDER BY
> S.stFullName, B.county, B.)
> Session halted.
> :"
>
> anybody else having a similar problem?
>

> worked fine for me. Maybe once again they were working on the site
> and you just caught them at a weak moment. Earlier this post was
> up.......

It looks like the errors are more a result of things that go wrong
when you search for a specific types of clues. So it'll work correctly
for people that don't use one type of search but won't work properly
if they search by region (or whatever the case may be).

Consequently, not everyone will see the error.

-- Ryan

We get the message when we check "What's New" which lists new boxes
in our area (NE Florida). Have been getting the message for the past
week when checking for new boxes.
Pyratemates



--- In letterbox-usa@yahoogroups.com, "rscarpen"
wrote:
>
> > worked fine for me. Maybe once again they were working on the site
> > and you just caught them at a weak moment. Earlier this post was
> > up.......
>
> It looks like the errors are more a result of things that go wrong
> when you search for a specific types of clues. So it'll work
correctly
> for people that don't use one type of search but won't work properly
> if they search by region (or whatever the case may be).
>
> Consequently, not everyone will see the error.
>
> -- Ryan
>

OK. I fixed that. Thanks,

Choi

On Fri, 28 Jul 2006 10:19:59 -0000
"pyratemates" wrote:
> We get the message when we check "What's New" which
>lists new boxes
> in our area (NE Florida). Have been getting the message
>for the past
> week when checking for new boxes.
> Pyratemates
>
>
>
> --- In letterbox-usa@yahoogroups.com, "rscarpen"
>
> wrote:
>>
>> > worked fine for me. Maybe once again they were working
>>on the site
>> > and you just caught them at a weak moment. Earlier
>>this post was
>> > up.......
>>
>> It looks like the errors are more a result of things
>>that go wrong
>> when you search for a specific types of clues. So it'll
>>work
> correctly
>> for people that don't use one type of search but won't
>>work properly
>> if they search by region (or whatever the case may be).
>>
>> Consequently, not everyone will see the error.
>>
>> -- Ryan
>>
>
>
>
>
>
>
>

The last set of errors were introduced when I added
automatic logging of each search and how long it took to
run. I forgot that when inserting the search into the
database, I had to get the quotes just right or it would
fail.

Choi

On Fri, 28 Jul 2006 06:06:03 -0000
"rscarpen" wrote:
>> worked fine for me. Maybe once again they were working
>>on the site
>> and you just caught them at a weak moment. Earlier this
>>post was
>> up.......
>
> It looks like the errors are more a result of things
>that go wrong
> when you search for a specific types of clues. So it'll
>work correctly
> for people that don't use one type of search but won't
>work properly
> if they search by region (or whatever the case may be).
>
> Consequently, not everyone will see the error.
>
> -- Ryan
>
>
>

THANK YOU, CHOI!!!! The link is working just fine. :D
Connfederate

--- In letterbox-usa@yahoogroups.com, wrote:
>
> OK. I fixed that. Thanks,
>
> Choi
>
> On Fri, 28 Jul 2006 10:19:59 -0000
> "pyratemates" wrote:
> > We get the message when we check "What's New" which
> >lists new boxes
> > in our area (NE Florida). Have been getting the message
> >for the past
> > week when checking for new boxes.
> > Pyratemates
> >
> >
> >
> > --- In letterbox-usa@yahoogroups.com, "rscarpen"
> >
> > wrote:
> >>
> >> > worked fine for me. Maybe once again they were working
> >>on the site
> >> > and you just caught them at a weak moment. Earlier
> >>this post was
> >> > up.......
> >>
> >> It looks like the errors are more a result of things
> >>that go wrong
> >> when you search for a specific types of clues. So it'll
> >>work
> > correctly
> >> for people that don't use one type of search but won't
> >>work properly
> >> if they search by region (or whatever the case may be).
> >>
> >> Consequently, not everyone will see the error.
> >>
> >> -- Ryan
> >>
> >
> >
> >
> >
> >
> >
> >
>

I for one am impressed with how well you keep this up! Way to go.
Lichen Hikin'

john@johnsblog.com wrote:
The last set of errors were introduced when I added
automatic logging of each search and how long it took to
run. I forgot that when inserting the search into the
database, I had to get the quotes just right or it would
fail.

Choi

On Fri, 28 Jul 2006 06:06:03 -0000
"rscarpen" wrote:
>> worked fine for me. Maybe once again they were working
>>on the site
>> and you just caught them at a weak moment. Earlier this
>>post was
>> up.......
>
> It looks like the errors are more a result of things
>that go wrong
> when you search for a specific types of clues. So it'll
>work correctly
> for people that don't use one type of search but won't
>work properly
> if they search by region (or whatever the case may be).
>
> Consequently, not everyone will see the error.
>
> -- Ryan
>
>
>






---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1/min.

[Non-text portions of this message have been removed]

Just wanted to say I think you do a fantastic job as webmaster. its
not the easiest thing to do and one wrong letter or digit and the code
won't work. thanks for making the LBNA site top notch. From the back
woods of Ledyard, CT, Myself, Mary and Norma say thanks!

Am I the only one having trouble with LBNA. MY homepage has the upper
1/2 with messages and all of my found symbols are gone from the clue
pages. My places are still there however. I rebotted my whole
computer but still have this anomaly unpon restarting and reentering
LBNA. Oh well, just wait it out. I am sure that Choi and crew are
already aware of it.
Safari Man TOD = 5:35 est.

Both LbNA and LbNE have been messed up for me.
the lazy letterboxer
----- Original Message -----
From: Safari Man
To: letterbox-usa@yahoogroups.com
Sent: Thursday, March 01, 2007 5:35 PM
Subject: [LbNA] LBNA website


Am I the only one having trouble with LBNA. MY homepage has the upper
1/2 with messages and all of my found symbols are gone from the clue
pages. My places are still there however. I rebotted my whole
computer but still have this anomaly unpon restarting and reentering
LBNA. Oh well, just wait it out. I am sure that Choi and crew are
already aware of it.
Safari Man TOD = 5:35 est.





[Non-text portions of this message have been removed]